create procedure [dbo].[BAEOrderProductCategoryLookupUpdate] @OrderProductID as
int,
    @OrderCategoryID AS int,
    @IsFeatured AS bit,
    @SortOrder AS int
AS
    UPDATE OrderProductCategoryLookup
    SET     
    OrderCategoryID = @OrderCategoryID,            
    IsFeatured = @IsFeatured,            
    SortOrder = @SortOrder        

    WHERE OrderProductID = @OrderProductID AND
    OrderCategoryID = @OrderCategoryID;

GO